Help With Calculated Export String

[rothdavid]

Hi:

I have an SQL table I am pulling data from. I have multiple values in single fields I want to export as seperate records. I have created a calucation field to make a tab seperated text string. The idea is to export this single field for each record and this field would export as if it were 2 records.

The tabs are recogized when the exported but the carriage returns (pilcrow in quotes or without quotes) appear as square blocks in the TAB file I am creating when a return is needed.

Calc Field:

Case ( RepCounts = 2 ; SplitRep1_Name &" "& Round ((dec_sizeValue * SplitRep1Percent);2) &" "& Round ((Net * SplitRep1Percent); 2) &"¶" &

SplitRep2_Name &" "& Round ((dec_sizeValue * SplitRep2Percent);2) &" "& Round ((Net * SplitRep2Percent); 2) ;

RepNames&" "& Round(dec_sizeValue;2) &" "& Round (Net ; 2) )

this example has two sales reps, that have a percentage of an ad sold. The calc field is listing both reps respective percentage of the sale itself.

Order has a 1pg ad at 10,000

the Export String is to generate:

Rep A.55,000

Rep A.55,000 (the last return is added when the export occurs)

I get this:

RepA .5 5000 [color:red]SQUARE SYMBOL RepB .5 5000

The tabs are part of the export but the Pilcrow doesn't export as a carriage return, just this square.

Can anyone provide assistance?

[mr_vodka]

Hi David,

Perhaps this post can help you.

http://fmforums.com/forum/showtopic.php?tid/193061