Forum Discussion
An Issue With Double Quotes In String Values
I am a software engineer that is going to be tasked with debugging a power app.
The app currently acquires a CSV file from an email account and parses it into a JSON file and then uses that file to load a power point list. And from there, the data is loaded into another file. The bug seems to be that character strings are altered by having double quotes at the beginning and end of the strings. This causes a logical flaw since strings are used in comparison and so we can get a false negative when we are comparing two strings which should be identical.
Is there a simple command which strips double quotes from strings that can be incorporated in a power BI set of steps?
- EricStarker
Community Manager
wm-thompson You've posted your question in the Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions.
Unfortunately we don't really have an area I can direct you to for this question, as Power Apps content is typically posted in a different community.
Feel free to check out the Power Apps community to ask your question: Power Apps Community - Power Platform Community (microsoft.com)
- Mich stört das ich jedes Mal auf Microsoft auf Deutsch Umstellen muss Seite für Seite
- Allen
Thank you for your feedback, the Microsoft Tech Community is an English only website I am afraid, Microsoft does have localized support channels via https://support.microsoft.com
- Hello wm-thompson,
What language is the app written in. I have yet to come across a programming language that did not have some sort of string manipulation (object, process, etc...). For instance, in VB (any version), you could remove the double quotes with something akin to this:
'in your parse routine
Dim myStr As String
myStr = Replace(stringWithQuotes,"""","")
Full transparency here; I know next to nothing about Power BI
HTH
