DSXchange

That works. Thanks!!

Basically my scenario is like...... There are either "DO NOT USE" or "ONLY USE" before the ** I am using your code and successfully able to store whatever I have after ** into OutData field or PrimaryName_USNAME in my mapping. Therefore, **Do Not Use** cotton & Welch, Inc wil...

I see COTON & WELSH , INC . as OutData. I anticipate to see COTON AND WELSH as OutData and, INC as NameSuffix_USNAME Basically, whatever we are putting in OutData should be Standardized again. Therefore, COTON & WELSH , INC needs to be standardized by USNAME rule set after the ** are removed...

Thanks for your help. I need little more help from you..... #\* | ** ; The last asterisk, followed by anything, eg: *** USE ABC # 123 *** NEW YORK COPY_S [1] {OutData} ;NOTE: Normally this would be [2], but this is a workaround because of the #\* RETYPE [1] 0 ;NOTE: Normally this would be [2], but t...

Appreciate it Robert. Thank you so much!!

Thanks Ray and RJDickson!! I would have another question.....do you know if there in any pattern action code I can add to USNAME.PAT file to get the string after the * (Asterisk)? For Instance.... *** USE ABC # 123 *** NEW YORK I like to store the information after last asterisk (i.e. NEW YORK) in A...

I am creating a job to clean addresses and then conform to USPS Postal Standard. Can I use AVI to cleanse and correct data to Postal Standard?

Also - can we get output fields from AVI with time zone (i.e. Eastern, Central, UTC/GMT) information?

Thanks in advance.

I need to calculate the distance in miles between two points. It doesn't have to be driving distance.....it can be simply the shortest distance between those two points. Thanks again for your input and feedback!!

Hello All,
I am trying to figure out how to calculate distance between Latitude/Longitude points. I am not sure if there is any built in functions in transformer stage I can use. Please advise. Thanks!!

Thanks a lot for your response!!! I am actually trying to see if AVI Stage is capable of being configured such a way that once it receives # it should convert automatically change to UNIT for that particular address. If you know any configuration changes that can make it happen please let me know. F...

I have the following for the address: AddressLineOne: 4999 BONITA BAY BLVD #1801 AddressLineTwo: AddressLineThree: City: BONITA SPRINGS ProvinceStateType: FL CountryType: USA I am expcting the address should be coming out after ran throuh AVI Stage is: 4999 BONITA BAY BLVD UNIT 1801 I have the patte...

Do you know what could be done to fix this error?

I changed the 'Lookup Failed' rule to 'Reject' and then connected to DataSet to catch the rejected row. It still aborts! Thanks in advance!!!

My 'Lookup Failed' rule is setup as given below: Condition Not Met --> Fail and Lookup Failur --> Fail Can you please suggest how to fix this error that I get while running: Lkp_Add_Updttm: Error occurred during initializeFromArgs(). Lkp_Add_Updttm: When processing argument -ifNotFoundWhen processin...

Hi All, I am having some issues with Lookup Stage. I have one dataset as source and another one as reference connected to lookup stage and then connected to a transformer stage to find the required records that will be loaded to Oracle table. While running I get the following error: Lkp_Add_Updttm: ...