Skip to main content
I have a csv with numerous fields that have ( 323244,232324245) and would like to know how i can get rid of the brackets and keep the data

Hi @giskmepf​ ,

 

Great question. You have a lot of options in this case, I would recommend one of the following: 

  • AttributeTrimmer (easiest in my opinion) - with the Trim Characters parameter set to:
( )

image

  • StringReplacer (REGEX allows for simple or complex matching) - Mode: Replace Regular Expression, Text to replace set to (leave the Replacement Text parameter blank. This is a great option if you are familiar with REGEX.
\(\s|\)

image

"( " "" ) ""

image 

If you need to split out the values from there, there is also an AttributeSplitter transformer that can help you split the values that are separated by commas (or any other value). 


Thank you , in addition if i had a field like this (240762.57423076924, 672975.6273076923)(240752.6821153846, 672976.7936538461) how would i format to just leave the values and the comma?


Thank you , in addition if i had a field like this (240762.57423076924, 672975.6273076923)(240752.6821153846, 672976.7936538461) how would i format to just leave the values and the comma?

Using the same suggestion as mentioned above, the one thing to keep in mind would be if your values are (240762.57423076924, 672975.6273076923)(240752.6821153846, 672976.7936538461), you may want to replace the )( first. Otherwise the second and third values would combine based on the suggestion above. Order is important in this case so you'd first want to replace the )(, then handle the remaining characters to replace. You can either handle all of this in a StringPairReplacer, where )( is the first string pair, or multiple StringReplacers.


Reply