In my FIELD RENAMER processor my input 6 columns looks like (1'result.name' , 2'result.adress.street' , 3'result.adress.city' , 4'result.adress.state', 5'result.adress.zip' , 6'result.phone' ) BUT I WANT these output as a column name like(1’name' 2'street' 3city' 4'state' 5'zip' ,6'phone' )And also want to achieve these output in single processor field renamer
Hello Lakshmi,
Have you spotted this option in the documentation, I have updated it to your example above
Remove a prefix or suffix
Say you want to remove an OPS prefix from a set of fields. You can do this by using the following expression to define the source fields to change:
/'result.adress.(.*)'
Then use the following expression to remove the OPS prefix:
/$1
Let me know if this works for you
Anth
To add on
Kindly check and let me know if it helps.
Hello Lakshmi,
Have you spotted this option in the documentation, I have updated it to your example above
Remove a prefix or suffix
Say you want to remove an OPS prefix from a set of fields. You can do this by using the following expression to define the source fields to change:
/'result.adress.(.*)'
Then use the following expression to remove the OPS prefix:
/$1
Let me know if this works for you
Anth
i tried the above mention code but i got this error
Record2-Error Record1 FIELD_RENAMER_00 - Record 'rawData::0_1_3' does not contain fields '/result\.(.*)' : (View Stack Trace... )
To add on
Kindly check and let me know if it helps.
yes I saw and tried that pipe line ,as you applied to achieve the out by applying another processor like field mapper. but my question is to achieve the output by single Renamer processor is Possibile or not.
Yes, we can handle it in one processor but it will be field specific . somehow I prepared the solution for you and its working as per case .
Can you please use this condition in field mapper processor as given below and it will solve your issue.
${str:contains(f:name(),'result.adress.') ? str:replaceAll(f:name(),'result.adress.','') : str:contains(f:name(),'result.') ? str:replaceAll(f:name(),'result.',''):f:name()}
Please let me know if it helps in your case or not.
Thanks & Regards
Bikram_
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.