Skip to main content
Question

String formatting getting lost in transformation

  • January 23, 2018
  • 8 replies
  • 22 views

sashal
Supporter
Forum|alt.badge.img+13

My strings lose their formatting once they hit my feature merger. Any help would be greatly appreciated.

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.

8 replies

sashal
Supporter
Forum|alt.badge.img+13
  • Author
  • Supporter
  • 33 replies
  • January 23, 2018
@daleatsafe

 

any ideas?

 


Forum|alt.badge.img+6
Hi @sashalockamy,

 

 

May we ask for a bit more information please? What kind of formatting is lost in the string? Do you have a sample workspace or data you can share with us? Screenshots would also help, if you would prefer not to share data.

 

 

It would also be great if you could share some details about the build of FME you are using as there have been some updates to the FeatureMerger since 2016.1.

 

 

Any assistance or information you are able to provide that helps narrow down the issue would be fantastic.

 

 

Cheers,

 

 

Annabelle

 

 


Forum|alt.badge.img+2
  • 325 replies
  • January 23, 2018
Please add some context to help everyone understand the problem to help you!

 

Give examples please.

 

 


sashal
Supporter
Forum|alt.badge.img+13
  • Author
  • Supporter
  • 33 replies
  • January 23, 2018

Sure. Below, at attributeManager_2 to inspection, my strings look great, but once they go through the FeatureMerger_3, the output reformats my strings...


sashal
Supporter
Forum|alt.badge.img+13
  • Author
  • Supporter
  • 33 replies
  • January 23, 2018

Sure. Below, at attributeManager_2 to inspection, my strings look great, but once they go through the FeatureMerger_3, the output reformats my strings...

here is the workspace...sp1-import-custom2.fmw

 

 

here is the desired output at shown in inspection results desired-output-inspection.png

 

 

here is the actual output which is no good because it reformatted my string to 2240 vs 0224 in the usaa_acct field actual-output-no-good.png

 

 


sashal
Supporter
Forum|alt.badge.img+13
  • Author
  • Supporter
  • 33 replies
  • January 23, 2018

@mark_1spatial I added info on my issue... will you please take a look?


sashal
Supporter
Forum|alt.badge.img+13
  • Author
  • Supporter
  • 33 replies
  • January 23, 2018

I was able to create a secondary workspace to merge two outputs and get the results I needed. Still not sure why the feature merger was changing my string length...


takashi
Celebrity
  • 7843 replies
  • January 24, 2018

Do you perhaps look at the resulting CSV table with Excel? Excel displays this CSV table like the screenshot below.

value
0019
019
19
0019-2240
019-2240
19-2240

0684Q00000ArLk5QAF.png

You have to inspect the CSV table with a Text Editor or FME Data Inspector to confirm whether the string format has been lost actually.Left: Text Editor (Notepad++), Right: Table View in FME Data Inspector

0684Q00000ArLhVQAV.png