http://forums.visokio.com/discussions/tagged/expand-values/feed.rss Mon, 30 Oct 17 21:11:38 -0400 Tagged with expand-values - Visokio Forums en-CA http://forums.visokio.com/discussion/2148/expand-values-splitting-text-into-multiple-columnss Thu, 16 May 2013 12:06:11 -0400 nicci113 2148@/discussions
What logic I can use to break while putting them in new columns whose name can be defined at the later stage. I need the excel logic for text to column .

Brand/abc/yahoo/Brand/Brand - bc URL - Exact/bc com/Exact]]> http://forums.visokio.com/discussion/1333/expand-values-operation-not-working-properly Thu, 23 Feb 2012 14:48:51 -0500 Pascal 1333@/discussions AAAAA|BBBBB|CCCCC|DDDDD|

I am trying to use the expand values but I am running into a problem.
Some of the fields separated by | just contain spaces and when that is the case, visokio just ignores that the field is there.

So, for example AAAAA|BBBBB|CCCCC|DDDDD| is split in five fields containing, AAAAA, BBBBB, CCCCC, DDDDD and an empty field.

But if I have a record like (I add " for clarity): " |XXXXX| |YYYYY|", then the first field will contain XXXXX (instead of being empty), the second YYYYY (instead of XXXXX), the third will be empty (correct but for the wrong reason), the fourth will be empty (instead of YYYYY) and the last one will be empty (always the case).

I unclick "Auto-convert to empty" in the excel import.

Is there a way visokio could put the right value in the right field or is it a bug?

Cheers,
Pascal.]]> http://forums.visokio.com/discussion/932/expand-values-add-columns-rather-than-overwrites Mon, 15 Aug 2011 05:06:02 -0400 steve 932@/discussions