I'm trying to process a JSON file and convert it to a CSV format using jq and sed. My goal is to replace decimal points with commas in one of the fields and ensure the output is properly formatted with…
I have a CSV File with the following data: 10, 23, 55, 123, 150 ... I have a Javascript File which I use in Adobe Illustrator. The following code creates 10 rectangles that are each shifted by 20 pixels and…
I have a CSV containing two "columns" 'User id' and 'email' example: User id,email 1234-1234-1234,[email protected] 321-1235-44432,[email protected] 322136231345,[email protected] And a JSON looking like this: [{ "externalId": "100000", "watchers": ["[email protected]", "[email protected]", "[email protected]"] }, { "externalId": "100002", "watchers": ["[email protected]", "[email protected]"] } ] What…
i have a big number of CSV files which should be filtered and eventually combined, sorted and get duplicate rows removed. so usually no big deal with sed and sort and i would achieve this with something like... sed -E…
Customer ID,First Name,Last Name,Email,Accepts Email Marketing,Company,Address1,Address2,City,Province Code,Country Code,Zip,Phone,Accepts SMS Marketing,Total Spent,Total Orders,Note,Tax Exempt,Tags '7271785759024,mehmet,bilgiç,,no,,,,,,,,+905343842739,no,0.00,0,,no, Hi i want to transfer my shopify customers csv file to another shopify account. But i always get error. error is: Customer ID not found I…
I used to be a jq masochist, but I discovered mlr, which seems to offer the opportunity for more (yet different) pain. I found a nice web site that allows me to issue curl commands without API keys, etc., to…
I am very new to python and I am trying to get the following JSON output from a csv file and the csv file looks like this date customer Ex employer emailID CIN CIN2 BatcheSource 9-Jul-24 ABC1 EmployerAnme1 [email protected] 123456…
I'm currently practicing converting plain text to csv, and them csv to json. I need to do the conversion only with jq and basic Linux commands. I didn't have any major problems converting plain text to csv, but further conversion…
There's a lot of discussion to convert JSON to CSV with jq, but can't find my situation. 2 points really blocking me : Get key and value of valuePerDay by row Sort valuePerDay keys to unsure values always in the…
I have a csv file that with rows that looks like this: 745198;2024-09-10 10:09:10.7;leaf-2;{"Accelerometer": {"X": 0.055297852, "Y": 0.993530273, "Z": 0.000244141}} 745199;2024-09-10 10:09:10.71;leaf-2;{"Accelerometer": {"X": 0.056274414, "Y": 0.994384766, "Z": 0.000976563}} 745200;2024-09-10 10:09:10.721;leaf-2;{"Accelerometer": {"X": 0.055786133, "Y": 0.994018555, "Z": 0.000854492}} 745201;2024-09-10 10:09:10.732;leaf-2;{"Accelerometer": {"X": 0.055053711,…