Adding an extra S to one word when exporting to csv

[waynec444]

This is very strange but true:

I exported a large file to csv (and then imported it into a database program).

Calc did something strange:

In the csv file: for every entry of /lifestyle/ or /lifestyles/ (in the csv file) it added an extra S at the end:

/lifestyles/ or if it already had /lifestyles/ it added another S at the end:

/lifestyless/

These are the ONLY strings that this happened to and it happened to ALL of them. Note that the above is part of multiple URLs.

What gives?

[RusselB]

I can't say for sure, but one option that occurs to me is that the exportation is using a regex so that the s/ is being taken to add an extra last character.
You might be able to confirm that this is not the case if you have other words that end in the s/ that do not obtain the extra S
If you can't confirm or deny that this is a possibility, based on your actual data, then the only option for a better answer that I can think of will require a sample file to be uploaded/attached so that we can examine the file and test ourselves.

[waynec444]

It has nothing to do with the /s as it also does it without the s (lifestyle/ only). It seems to favor the word "lifestyle" to add the extra s to it.

As the data is not public I cannot upload the file. Hope you understand.

[Villeroy]

As the data is not public I cannot upload the file. Hope you understand.

Nobody understands anything without having a file helping to reproduce this weirdness. The content of the file does not matter. Just some file and exact instructions what to do with it in order to get the same weird results.

[robleyd]

A post in [Forum] How to attach a document here gives some ideas for anonymising your data.

[waynec444]

Great. Here is the anonymized attached file. Remember, the problem is with ONLY lifestyle and lifestyles. No other words have been modified with the added S or in any other way.

Please note the file was much larger than allowed for upload. So I removed almost all FROM THE MIDDLE. Left intact the start and end of the document.

[robleyd]

The sample file has only one occurrence of the string "lifestyle, viz.:

xxxxx://xxxxxxxxxxxx.xxx/Cxxxxxx/Dxxxxxx/LIFESTYLE/-3/1213,

Your original question says "In the csv file: for every entry of /lifestyle/ or /lifestyles/ (in the csv file) it added an extra S at the end:". The content of the csv file you provided doesn't show this behaviour.

Have you checked the actual content of a csv file and seen this in the file? If not, it might be somehow related to the process of importing into the unspecified database?