Character Removal Question

Previous topic - Next topic

jeffs42885

I've never had to do this before and I was wondering if someone has seen a similar scenario.

I am generating a PDF file using AFP2PDF and here is a sample output that is generated using Ricohs AVE tool:

CODEPAGE:819
COMMENT: ================
GROUP_FIELD_NAME:ldate
GROUP_FIELD_VALUE:09/30/2013
GROUP_FIELD_NAME:lname
GROUP_FIELD_VALUE:A LASTNAME
GROUP_FIELD_NAME:plan
GROUP_FIELD_VALUE:111111
GROUP_FIELD_NAME:planname
GROUP_FIELD_VALUE:JEFFS410k
GROUP_FIELD_NAME:refnum
GROUP_FIELD_VALUE:002123412342
GROUP_FIELD_NAME:ssn
GROUP_FIELD_VALUE:111111111
GROUP_OFFSET:0
GROUP_LENGTH:48341
GROUP_FILENAME:/ODPROCESS/FILE1111.1381505392310.A12.ZS1234_0.0.175149.ARD.out
COMMENT: ================

For the field lname, I want to remove the A before LASTNAME. I have tried many possible combinations using the application setting for character removal and it has not worked. Is there a way that I can remove a character followed by a space...so that instead of loading A LASTNAME into the database it would just load LASTNAME

Justin Derrick

You might want to write a custom pre-processor.  I can't think of a clever way to say <match anything><space><leave the rest> with character removal.  For the most part, character removal is used for removing a series of characters from ANYWHERE within the string.  I don't think that character removal has support for regular expressions.  I could do this in Perl in 8 or 10 lines.

Let us know how you resolve this!

-JD.
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Webinars:  https://CMOD.Training/
IBM CMOD Professional Services: https://CMOD.cloud

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

LWagner

That can be done with a script in the post-processor parameters.

We did this in our conversion and data migration process from AFP in CMOD 2.1 to CMOD 8.4.

Our amounts lacked a decimal point, which we inserted via post-processor using an awk script.