Skip to main content
Solved

How to split one column to two columns ?

  • August 18, 2023
  • 1 reply
  • 134 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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

daveatsafe
Safer
Forum|alt.badge.img+19
  • daveatsafeSafer
  • Safer
  • 1637 replies
  • 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.

Community Stats

32,070
Posts
121,771
Replies
39,696
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.