Macro wrongly converting decimal seperator

[Hamder83]

Hi 

Im using an alteryx xlsx to csv converter, which converts , to . in the output.

Any way to change this ?

Using this macro 


kind regards

[DavidP]

could you provide an input file for the macro?

[Hamder83]

Hi 

Here is a copy of my input file 🙂 

[DavidP]

Hi @Hamder83, thanks for providing the input file.

I've had a look through the macro and what it's doing, but I can't really figure out what you want help with 🙂

Could you specifically show me or explain what the problem is you want us to look at?

Is this your macro or someone else's?

[Hamder83]

Hi David 

Thanks for your reply, 

im from Denmark - we use , as decimal seperator and . as thousand seperator.

The input file has this format. But the csv file that the macro outputs has . as decimal seperator.

And I just wanna keep the format from the input file.


Its a macro ive downloaded 

[vishnuharinarayanan]

Hi,

Do you need the output file to be like shown below:

If so, can you please use Multi Field Formula tool , and replace the "." with "," using the expression as shown below:

Please make sure to convert the Input fields into String datatype before applying the formula.

Please let me know if it works.

[DavidP · Accepted solution]

I think one of the problems here is, if there are commas (,) in your data and you write it to a CSV that uses comma as a separator, it will mess up the structure of your data.

I looked at the file and what the macro does and I think it's probably easier just to build the workflow from scratch without the macro. It seems that there is a structure in the Excel file that we can rely on, so have a look at the attached workflow and let me know if it works for you.

I've changed the CSV delimiter to a pipe (|) rather than a comma, but this can easily be changed in the Output data tool if you like, as long as it's not a comma.

[Hamder83]

Hi David 

Thanks for the effort, 

Though, if I run your workflow I still get the csv with dot's? 

Am i doing anything wrong ? 

I tried with the macro to change the delmmiter to something different, but it still does not work.

[DavidP]

The dots are in the input file as shown below when read with an Input Data tool. In your earlier post you mentioned that you want to write the data in the same format as the input file.

Am I correct then in saying that in these fields, the dot represents a decimal

Grundpris	SMS - service	Miljøtillæg	I alt (excl. moms)
63.55	0	1.27	64.82
30.4	0	0.61	31.01
32.07	0	0.64	32.71
32.07	0	0.64	32.71
32.07	0	0.64	32.71
32.07	0	0.64	32.71

but in these fields the dots represent a thousand separator

Vægt	Volumenvægt	Faktureret vægt
4.600	33.370	33.370
1.750	3.776	3.776
1.500	5.700	5.700
1.540	5.400	5.400
2.800	7.375	7.375
0.500	6.054	6.054

If so, you can use the multi-field formula as suggested by @vishnuharinarayanan 

Updated workflow attached.

[Hamder83]

Hi again

And thanks for the effort, again! 🙂 

My input data has comma as decimal seperator both in price and weight.

So prefferably it should just keep the format of the input file?

Nor price or weight has a thousand seperator, its weight(vægt9 in kilo so its 33,370 kg? 🙂