Skip to main content
Solved

How to split one column to two columns ?

  • August 18, 2023
  • 1 reply
  • 73 views

spiderman
Contributor
Forum|alt.badge.img+7

Hello ,

How to split the content of one column to two columns ?

my output of aggregator looks like string12-string56 at same cell in one column and all rows similar .

 

i would like to have two attributes one called base include string12 and other attribute called next include string56 and implement the method for all rows

 

Which transformer should i use ?how to use it ?

fme 2021

thanks in advance

 

Best answer by daveatsafe

Hi @spiderman​,

You can use the AttributeSplitter to split based on the number of columns or separator character. For more complex attribute splitting using Regular Expressions, you can use the Advanced options in the StringSearcher.

View original
Did this help you find an answer to your question?

1 reply

daveatsafe
Safer
Forum|alt.badge.img+19
  • Safer
  • Best Answer
  • August 18, 2023

Hi @spiderman​,

You can use the AttributeSplitter to split based on the number of columns or separator character. For more complex attribute splitting using Regular Expressions, you can use the Advanced options in the StringSearcher.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings