.
#Excel
nova grail
hey
not doiing this task using excel dude 😢
the data is just too much and i dont know what to do 😿
Navneet Roller Flour Mill:
Works: E-191
Off: 123-
Phone: 0141
Phone 2: 0
Mobile: 941
Products: Att
lets say everything here is having key and value using just simple code i can call it and save the data into columns but the deal here Navneet Roller Flour Mill:
name of all the business are in this format instead of this
name : Navneet Roller Flour Mill
now if i am calling them python is just ignoring them 🥹
if i try to assign them key it just ignore it
sand briar
hmm okay
I'm not sure i understand what you want
could you give me a quick example?
nova grail
sure
Navneet Roller Flour Mill:
Works: E-191 Hoorawala Indi Area Kanaka JAIPUR-303012
Off: 123-124 1st Floor Pink City Tower Near Pital Factory D-202 Jhotwara Road JAIPUR-302016
Phone: 902
Phone 2: 01429
Mobile: 94140 or 93145
Products: Atta Maida Suji
M.R. Food Products:
Address: Near Chamra Home Khoda Ganeshji Road MADANGANJ-KISHANGARH
Phone: 01497
Mobile: 12345
Products: Atta Maida Suji
Nav Durga Roller Flour Mill:
Address: G-249 Kami Industrial Area BIKANER
Phone: 32059712
Mobile: 94133 and 54133
Email: nd@gmail.com
Products: Alta Maida Su
if you see this
Navneet Roller Flour Mill:
M.R. Food Products:
Nav Durga Roller Flour Mill:
these 3 are the name of the business and below there details now if i want to get the details of these business and store them in excel sheet by assigning some coloumns to them like
columns *
address number and etc i can it can be done because it has key : value
like
mobile : 12345
but name of the business is like this
Navneet Roller Flour Mill:
M.R. Food Products:
Nav Durga Roller Flour Mill:
i am not able to get them
i am trying since morning to do this and 3 hours for now but now able to do this 😢
nova grail
Navneet Roller Flour Mill:
Works: E-191 Hoorawala Indi Area Kanaka JAIPUR-303012...
this is just sample data of the text file is there any way i can get all the information and store in columns like name address and number
yes always the first one then it has key and value
Navneet Roller Flour Mill: here name
Works: E-191 Hoorawala Indi Area Kanaka JAIPUR-303012
Off: 123-124 1st Floor Pink City Tower Near Pital Factory D-202 Jhotwara Road JAIPUR-302016
Phone: 902
Phone 2: 01429
Mobile: 94140 or 93145
Products: Atta Maida Suji
M.R. Food Products: here name
first one is always the name of the firm then it will have the info the firm then again same thing
sand briar
this is just sample data of the text file is there any way i can get all the inf...
in what, python?
nova grail
yes i am doing this in python but no solution also tried to do this in gpt 3.5 still got nothing
tried lot many codes nothing is wokring 😿
sand briar
hmm
maybe try splitting by return to line
and adding excel delimiters
and if there isnt a :
you can add it to the line
like Name: ...
nova grail
Let me try it
The main issue is there is no fixed pattern sometimes after 3-4 lines- name of the firm and sometimes 4-5
Lets see i will try today
nova grail
worked bro