Apply map

[Santhoshmdm]

Hi,

I am trying to replace a string in a particular field by using the Apply map function. Inline mapping function was used and I am not sure how the long strings are mentioned inside the inline table brackets. Tried by uploading the table from and excel spreadsheet and it is working fine,but not sure how to mention the long strings in the inline table itself. Please help and thanks in advance 

[AshutoshBhumkar]

Hi, can you provide any sample data to work on.

[Santhoshmdm]

Thanks for looking into that. please find the below inline table which I need to be executed. When I execute the below Inline table, there are syntax errors which I need your help to rectify. Thanks in advance.

mapping LOAD * Inline[

'aaaaaaaaa aaaaaaa aaaaaaaaaaaaaa-1', 'bbbbbb-----bbbbbbbbbbbbbbbbbbbbbbbbbbbbbb'
‘filtration Filter 2bbbbbbbbbbbbbbbb,  ‘abababababaaaation TMP after lter 2 [bar]’
‘asasasasasaaaaaaaaaskjtion Filter 1,  ‘re end of Virus filtration Filter 1 [bar]’
‘hfgfhfgfh Virus filtration Filter 2, ‘before end of Virus filtration hdtefredse hd’
'Process fgdrtessasaasa filtration,  ‘ion Process Pause during Virus filtration [-]’
‘asasasassssssssss to Post-Wash, ‘ration Process Pause for Change to Post-Wash [-‘

];

[AshutoshBhumkar]

Hi,

You can use " " (Double Quotes) instead of inline brackets like below, if there are brackets used in Inline table data.

mapping LOAD * Inline "

'aaaaaaaaa aaaaaaa aaaaaaaaaaaaaa-1', 'bbbbbb-----bbbbbbbbbbbbbbbbbbbbbbbbbbbbbb'
‘filtration Filter 2bbbbbbbbbbbbbbbb,  ‘abababababaaaation TMP after lter 2 [bar]’
‘asasasasasaaaaaaaaaskjtion Filter 1,  ‘re end of Virus filtration Filter 1 [bar]’
‘hfgfhfgfh Virus filtration Filter 2, ‘before end of Virus filtration hdtefredse hd’
'Process fgdrtessasaasa filtration,  ‘ion Process Pause during Virus filtration [-]’
‘asasasassssssssss to Post-Wash, ‘ration Process Pause for Change to Post-Wash [-‘

" ; 

[Santhoshmdm]

Unfortunately this is not working. There is no syntax error but the AppyMap function is not working as expected. if the field has the value, aaaaaaaaa aaaaaaa aaaaaaaaaaaaaa-1 then need the value to be displayed is 'bbbbbb-----bbbbbbbbbbbbbbbbbbbbbbbbbbbbbb'. When using the double quotes, the value displayed is aaaaaaaaa aaaaaaa aaaaaaaaaaaaaa-1.